/*
Navicat MySQL Data Transfer

Source Server         : job
Source Server Version : 50528
Source Host           : localhost:3306
Source Database       : wedding

Target Server Type    : MYSQL
Target Server Version : 50528
File Encoding         : 65001

Date: 2020-06-14 21:58:38
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` char(15) DEFAULT NULL,
  `phone` int(20) DEFAULT NULL,
  `ktime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `jurisdiction` char(50) DEFAULT NULL,
  `opreation` char(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=667 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('100', '白岩松', '15262932', '2020-06-14 21:21:56', '主持人管理，新人管理，合作伙伴管理', '编辑 删除');
INSERT INTO `admin` VALUES ('111', '白岩松', '15262932', '2020-06-14 21:22:12', '主持人管理，新人管理，合作伙伴管理', '编辑 删除');
INSERT INTO `admin` VALUES ('222', '白岩松', '15262932', '2020-06-14 21:22:13', '主持人管理，新人管理，合作伙伴管理', '编辑 删除');
INSERT INTO `admin` VALUES ('333', '白岩松', '15262932', '2020-06-14 21:22:13', '主持人管理', '编辑 删除');
INSERT INTO `admin` VALUES ('444', '白岩松', '15262932', '2020-06-14 21:22:14', '主持人管理', '编辑 删除');
INSERT INTO `admin` VALUES ('555', '白岩松', '15262932', '2020-06-14 21:22:18', '主持人管理', '编辑 删除');

-- ----------------------------
-- Table structure for `ceremony`
-- ----------------------------
DROP TABLE IF EXISTS `ceremony`;
CREATE TABLE `ceremony` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `person` char(50) DEFAULT NULL,
  `company` char(30) DEFAULT NULL,
  `compere` char(20) DEFAULT NULL,
  `hotel` char(50) DEFAULT NULL,
  `site` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `date` datetime DEFAULT NULL,
  `paice` int(30) DEFAULT NULL,
  `indent` char(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ceremony
-- ----------------------------
INSERT INTO `ceremony` VALUES ('1', '小美19969986673', '北京XX策划公司', '白岩松', '香格里拉', '2020-06-14 21:44:27', '2020-06-14 21:41:50', '2000', '待主持');
INSERT INTO `ceremony` VALUES ('2', '小美19969986673', '新人', '白岩松', '香格里拉', '2020-06-14 21:44:33', '2020-06-14 21:41:54', '2000', '已删除');
INSERT INTO `ceremony` VALUES ('3', '小美19969986673', '新人', '白岩松', '香格里拉（外址+1000）', '2020-06-14 21:45:00', '2020-06-14 21:41:57', '2000', '已主持');

-- ----------------------------
-- Table structure for `company`
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` char(50) DEFAULT NULL,
  `phone` char(50) DEFAULT NULL,
  `email` char(20) DEFAULT NULL,
  `time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `math` int(10) DEFAULT NULL,
  `state` char(20) DEFAULT NULL,
  `operation` char(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES ('1', 'XXXX婚礼策划', '张三17352638691', '156@qq.com', '2020-06-14 20:48:32', '18', '正常', '编辑  策划师列表  账号管理');
INSERT INTO `company` VALUES ('2', 'XXXX婚礼策划', '张三17352638691', '156@qq.com', '2020-06-14 20:58:05', '18', '未审核', '编辑  策划师列表  账号管理');
INSERT INTO `company` VALUES ('3', 'XXXX婚礼策划', '张三17352638691', '156@qq.com', '2020-06-14 20:58:21', '18', '禁用', '编辑  策划师列表  账号管理');
INSERT INTO `company` VALUES ('4', 'XXXX婚礼策划', '张三17352638691', '156@qq.com', '2020-06-14 20:57:46', '18', '正常', '编辑  策划师列表  账号管理');
INSERT INTO `company` VALUES ('5', 'XXXX婚礼策划', '张三17352638691', '156@qq.com', '2020-06-14 20:57:43', '18', '正常', '编辑  策划师列表  账号管理');
INSERT INTO `company` VALUES ('6', 'XXXX婚礼策划', '张三17352638691', '156@qq.com', '2020-06-14 20:57:42', '18', '正常', '编辑  策划师列表  账号管理');

-- ----------------------------
-- Table structure for `compere`
-- ----------------------------
DROP TABLE IF EXISTS `compere`;
CREATE TABLE `compere` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `name` char(20) DEFAULT NULL,
  `phone` int(50) DEFAULT NULL,
  `email` char(50) DEFAULT NULL,
  `time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `account` char(20) DEFAULT NULL,
  `opreation` char(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of compere
-- ----------------------------
INSERT INTO `compere` VALUES ('1', '白岩松', '156896536', null, '2020-06-14 21:51:42', '正常', '账号禁用');
INSERT INTO `compere` VALUES ('2', '白岩松', '156896536', null, '2020-06-14 21:51:43', '正常', '账号禁用');
INSERT INTO `compere` VALUES ('3', '白岩松', '156896536', null, '2020-06-14 21:51:43', '禁用', '账号禁用');
INSERT INTO `compere` VALUES ('4', '白岩松', '156896536', null, '2020-06-14 21:51:44', '正常', '账号禁用');
INSERT INTO `compere` VALUES ('5', '白岩松', '156896536', null, '2020-06-14 21:51:45', '正常', '账号禁用');
INSERT INTO `compere` VALUES ('6', '白岩松', '156896536', null, '2020-06-14 21:51:46', '正常', '账号禁用');

-- ----------------------------
-- Table structure for `designstion`
-- ----------------------------
DROP TABLE IF EXISTS `designstion`;
CREATE TABLE `designstion` (
  `

释义
权威词典
用法
例句

go top 
designation` char(50) NOT NULL DEFAULT '',
  `max` int(30) DEFAULT NULL,
  `min` int(30) DEFAULT NULL,
  PRIMARY KEY (`

释义
权威词典
用法
例句

go top 
designation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of designstion
-- ----------------------------
INSERT INTO `designstion` VALUES ('首席主持人', '6000', '9000');
INSERT INTO `designstion` VALUES ('首席主持人1', '9000', '20000');
INSERT INTO `designstion` VALUES ('首席主持人2', '3000', '6000');

-- ----------------------------
-- Table structure for `essay`
-- ----------------------------
DROP TABLE IF EXISTS `essay`;
CREATE TABLE `essay` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `title` char(50) DEFAULT NULL,
  `time` time DEFAULT NULL,
  `operation` char(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of essay
-- ----------------------------
INSERT INTO `essay` VALUES ('1', 'XXXX团队成立了', '21:31:45', '编辑   删除');
INSERT INTO `essay` VALUES ('2', 'XXXX团队成立了', '21:32:06', '编辑   删除');
INSERT INTO `essay` VALUES ('3', 'XXXX团队成立了', '21:32:08', '编辑   删除');
INSERT INTO `essay` VALUES ('4', null, null, null);
INSERT INTO `essay` VALUES ('5', null, null, null);
INSERT INTO `essay` VALUES ('6', null, null, null);

-- ----------------------------
-- Table structure for `history`
-- ----------------------------
DROP TABLE IF EXISTS `history`;
CREATE TABLE `history` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` char(15) DEFAULT NULL,
  `admin` float(12,0) DEFAULT NULL,
  `fee` int(12) DEFAULT NULL,
  `payable` float(15,0) DEFAULT NULL,
  `state` char(30) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `operation` char(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of history
-- ----------------------------
INSERT INTO `history` VALUES ('1', '张三', '500', '0', '500', '待缴纳', '2020-06-14 21:13:03', '');
INSERT INTO `history` VALUES ('2', '李四', '600', '100', '600', '待缴纳，一级延迟', '2020-06-14 21:13:17', '');
INSERT INTO `history` VALUES ('3', '王五', '750', '250', '750', '待缴纳，二级延迟', '2020-06-14 21:13:28', '');
INSERT INTO `history` VALUES ('4', '赵六', '500', '0', '500', '已正常缴纳', '2020-06-14 21:14:33', '编辑   删除');
INSERT INTO `history` VALUES ('5', '刘德华', '600', '100', '600', '已缴纳，一级延迟', '2020-06-14 21:13:54', '');
INSERT INTO `history` VALUES ('6', '白岩松', '750', '0', '750', '已缴纳，二级延迟', '2020-06-14 21:14:09', '');
